
 

create table Person
(
   Id int primary key not null identity,
   FristName varchar not null,
   LastName varchar(80) not null
)
go

create table Address
(
   Id int primary key not null identity,
   PersonId int not null,
   City varchar(80),
   States varchar(80)
)

select * from Person
select * from Address

select a.Id, a.FristName, a.LastName, b.Id as AddressId,b.City ,b.States from Person a
left join Address b on a.Id=b.PersonId